
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[ReportBaseObjectDeleteAllInBookmark]
    @BookmarkId INT ,
    @IsGroup BIT
AS 
    BEGIN
    
        UPDATE  ReportBaseObject
        SET     Deleted = 1
        WHERE   ( @IsGroup = 1
                  AND WordBookmarkId = @BookmarkId
                )
                OR ( @IsGroup = 0
                     AND BookmarkGroupId = @BookmarkId
                   )
    END
GO
